Log Database

If you want to log to a database (mssql or postgresql) you can set the log database location in the setting file (default FastBCP_settings.json file or a custom location and settings file name using --settingsfile parameter)

You can change the connection string inside the settings file.

Sample Connection String for mssql

"MS_FastTransferLogs": "Server=localhost;Database=FastTransferLogs;Integrated Security=SSPI;Encrypt=True;TrustServerCertificate=True"

Custom Connection Example

"MS_FastTransferLogs": "Server=mssqlloginstance,2433;Database=FastTransferLogs;Integrated Security=SSPI;Encrypt=True;TrustServerCertificate=True"

Use a correct connection string for your log database.

A complete configuration example is available in the Configuration Examples page.

Information

In case the database is not reachable, FastBCP will fail and will refuse to continue. If you want to continue without logging in the database, you can rename the FastBCP_settings.json file to something else (like FastBCP_settings.json.save) and FastBCP will use the console log only.